Analysis of Tablets from Amazon¶

image-5.png

Analyzing data of all tablets from amazon.com. Scraped using Scrapy¶

Goal, to analyze differences in products and compare to Amazons brand of tablets, Fire HD tablets.¶

Products were analyzed by Rating of product in stars, number of reviews, popularity, and commonly used words by the seller to market their product.¶

Challenges in Scraping Amazon¶

  • Multiple xpaths and tags were needed in order to properply scrape data, and even then some did not scrape appropriately
  • Wanted to Scrape Technical details table for system specs however there was no consistency in any of the table formats or tags. Some Technical details page only showed an image rather than a table making it difficult to scrape
  • Thus the description was parsed and word cloud was used to see what the common specs were

First lets read the csv file generated by scrapy¶

image.png

All Pages of Tablets from amazon scrapped¶

brand description num_reviews price rating title
0 Dragon ,,[ Native and Latest Android OS ] The Max10 u... 816 ratings $149.99 4.4 out of 5 stars Dragon Touch Max10 Tablet, Android 10.0 OS, Oc...
1 Hoozo ,,【Latest Ver. Tablets】: Android 8.1 Go OS, 1.... 2,099 ratings $91.77 3.9 out of 5 stars Android Tablet 10 Inch, 5G WiFi Tablet, 16 GB ...
2 vankyo ,,Faster and More responsive: Equipped with th... 1,711 ratings $74.99 4.4 out of 5 stars VANKYO MatrixPad S7 7 inch Tablet, Android 9.0...
3 Dragon ,,[Strong and Powerful Performance]: Do what y... 4,595 ratings $119.99 4.4 out of 5 stars Dragon Touch Notepad K10 Tablet, 10 inch Andro...
4 Amazon A Certified Refurbished Fire 7 Tablet is refur... 2,140 ratings $59.99 4.4 out of 5 stars Certified Refurbished Fire 7 Tablet (7" displa...
... ... ... ... ... ... ...
9571 Fusion5 ,,10.1 INCH POWERFUL OCTA-CORE TABLET PC WITH ... NaN $159.95 NaN Fusion5 10.1" 2in1 Google Certified Android La...
9572 Samsung ,,Minimal bezel. Maximum view. Watch, stream a... 8,882 ratings $206.68 4.7 out of 5 stars SAMSUNG SM-T510NZDFXAR Galaxy Tab A 10.1 64 GB...
9573 Amazon 8" HD display, 2X the storage (32 or 64 GB of ... 30,108 ratings $89.99 4.5 out of 5 stars All-new Fire HD 8 tablet, 8" HD display, 32 GB...
9574 Amazon 10.1" 1080p full HD display; 32 or 64 GB of in... 77,593 ratings $149.99 4.6 out of 5 stars Fire HD 10 Tablet (10.1" 1080p full HD display...
9575 Amazon 7" IPS display; 16 or 32 GB of internal storag... 110,184 ratings $49.99 4.4 out of 5 stars Fire 7 tablet (7" display, 16 GB) - Black

9576 rows × 6 columns

  • Using Scrapy I was able to scrape the following variables: Brand, Description, number of reviews, price, rating, and title
  • Scrapy was able to scrape over 9000 products!
  • However we want to omit 'Renewed' and 'Refurbished' entries to prevent duplicates
  • We also want to remove products which are not tablets
brand description num_reviews price rating title
0 Dragon ,,[ Native and Latest Android OS ] The Max10 u... 816 ratings $149.99 4.4 out of 5 stars Dragon Touch Max10 Tablet, Android 10.0 OS, Oc...
1 Hoozo ,,【Latest Ver. Tablets】: Android 8.1 Go OS, 1.... 2,099 ratings $91.77 3.9 out of 5 stars Android Tablet 10 Inch, 5G WiFi Tablet, 16 GB ...
2 vankyo ,,Faster and More responsive: Equipped with th... 1,711 ratings $74.99 4.4 out of 5 stars VANKYO MatrixPad S7 7 inch Tablet, Android 9.0...
3 Dragon ,,[Strong and Powerful Performance]: Do what y... 4,595 ratings $119.99 4.4 out of 5 stars Dragon Touch Notepad K10 Tablet, 10 inch Andro...
4 Amazon A Certified Refurbished Fire 7 Tablet is refur... 2,140 ratings $59.99 4.4 out of 5 stars Certified Refurbished Fire 7 Tablet (7" displa...
... ... ... ... ... ... ...
9571 Fusion5 ,,10.1 INCH POWERFUL OCTA-CORE TABLET PC WITH ... NaN $159.95 NaN Fusion5 10.1" 2in1 Google Certified Android La...
9572 Samsung ,,Minimal bezel. Maximum view. Watch, stream a... 8,882 ratings $206.68 4.7 out of 5 stars SAMSUNG SM-T510NZDFXAR Galaxy Tab A 10.1 64 GB...
9573 Amazon 8" HD display, 2X the storage (32 or 64 GB of ... 30,108 ratings $89.99 4.5 out of 5 stars All-new Fire HD 8 tablet, 8" HD display, 32 GB...
9574 Amazon 10.1" 1080p full HD display; 32 or 64 GB of in... 77,593 ratings $149.99 4.6 out of 5 stars Fire HD 10 Tablet (10.1" 1080p full HD display...
9575 Amazon 7" IPS display; 16 or 32 GB of internal storag... 110,184 ratings $49.99 4.4 out of 5 stars Fire 7 tablet (7" display, 16 GB) - Black

7057 rows × 6 columns

Removal of refurbished and renewed devices¶

brand description num_reviews price rating title
0 Dragon ,,[ Native and Latest Android OS ] The Max10 u... 816 ratings $149.99 4.4 out of 5 stars Dragon Touch Max10 Tablet, Android 10.0 OS, Oc...
1 Hoozo ,,【Latest Ver. Tablets】: Android 8.1 Go OS, 1.... 2,099 ratings $91.77 3.9 out of 5 stars Android Tablet 10 Inch, 5G WiFi Tablet, 16 GB ...
2 vankyo ,,Faster and More responsive: Equipped with th... 1,711 ratings $74.99 4.4 out of 5 stars VANKYO MatrixPad S7 7 inch Tablet, Android 9.0...
3 Dragon ,,[Strong and Powerful Performance]: Do what y... 4,595 ratings $119.99 4.4 out of 5 stars Dragon Touch Notepad K10 Tablet, 10 inch Andro...
5 PRITOM ,,★[HIGH PERFORMANCE ANDROID TABLET ] - Pritom... 235 ratings $89.99 4.0 out of 5 stars Android Tablet Pritom 10 inch Android 9.0 OS T...
... ... ... ... ... ... ...
9571 Fusion5 ,,10.1 INCH POWERFUL OCTA-CORE TABLET PC WITH ... NaN $159.95 NaN Fusion5 10.1" 2in1 Google Certified Android La...
9572 Samsung ,,Minimal bezel. Maximum view. Watch, stream a... 8,882 ratings $206.68 4.7 out of 5 stars SAMSUNG SM-T510NZDFXAR Galaxy Tab A 10.1 64 GB...
9573 Amazon 8" HD display, 2X the storage (32 or 64 GB of ... 30,108 ratings $89.99 4.5 out of 5 stars All-new Fire HD 8 tablet, 8" HD display, 32 GB...
9574 Amazon 10.1" 1080p full HD display; 32 or 64 GB of in... 77,593 ratings $149.99 4.6 out of 5 stars Fire HD 10 Tablet (10.1" 1080p full HD display...
9575 Amazon 7" IPS display; 16 or 32 GB of internal storag... 110,184 ratings $49.99 4.4 out of 5 stars Fire 7 tablet (7" display, 16 GB) - Black

6508 rows × 6 columns

Export csv of cleaned data¶

image.png

  • Upon inspecting the csv file, all refurbished and renewed devices have been omitted!
  • Now we can analyze only orginal posts without having to worry about inflated values due to duplicates




Most Listed Tablet Brands on Amazon¶

Dongdexiu    303
Microsoft    166
SAMSUNG      145
Oudi         135
Chichi       123
Name: brand, dtype: int64

Interestingly the brands with the most products on Amazon are:¶

  • Dongdexiu
  • Microsoft
  • Oudi
  • Chichi

Most Popular Tablets by number of ratings¶

If you google most popular tablet brands these 6 come up.¶

  • Apple
  • Samsung
  • Amazon
  • Lenovo
  • Microsoft
  • Asus

Upon inspecting the raw data these brands were shown to have devices with number of reviews over 1,000 and at least a 4-star rating.¶

Lets sort the data frames by Top brands and number of reviews¶

brand description num_reviews price rating title reviews_float
9439 Apple 10. 2-inch Retina display,A10 Fusion chip,Touc... 45,831 ratings NaN 4.8 out of 5 stars Apple iPad (10.2-inch, Wi-Fi, 32GB) - Gold (Pr... 45831.0
1164 Apple 9.7-inch Retina display,A10 Fusion chip,Touch ... 16,445 ratings $459.00 4.8 out of 5 stars Apple iPad (Wi-Fi + Cellular, 32GB) - Silver (... 16445.0
1214 Apple 9.7-inch Retina display,A10 Fusion chip,Touch ... 16,445 ratings $459.00 4.8 out of 5 stars Apple iPad (Wi-Fi + Cellular, 32GB) - Silver (... 16445.0
9504 Apple 7.9-inch Retina Display with True Tone and wid... 7,113 ratings $384.99 4.8 out of 5 stars Apple iPad mini (Wi-Fi, 64GB) - Gold (Latest M... 7113.0
469 Apple ,,Apple iOS 8; 9.7-Inch Retina Display; 2048x1... 6,426 ratings NaN 4.7 out of 5 stars Apple iPad Air 2 MGTX2LL/A 9.7-inches 128 GB T... 6426.0
brand description num_reviews price rating title reviews_float
9572 Samsung ,,Minimal bezel. Maximum view. Watch, stream a... 8,882 ratings $206.68 4.7 out of 5 stars SAMSUNG SM-T510NZDFXAR Galaxy Tab A 10.1 64 GB... 8882.0
9570 Samsung ,,Minimum bezel. Maximum view: Designed with a... 5,572 ratings $99.99 4.6 out of 5 stars SAMSUNG SM-T290NZSAXAR, Galaxy Tab A 8.0" 32 G... 5572.0
9175 Samsung ,,Android 4.4 Kit Kat OS, 1.2 GHz quad-core pr... 4,271 ratings NaN 4.4 out of 5 stars Samsung Galaxy Tab 4 (7-Inch, White) 4271.0
481 Samsung ,,1.6 GHz exynos 7870 octa core Processor. 10.... 3,813 ratings NaN 4.5 out of 5 stars Samsung Galaxy Tab A SM-T580NZKAXAR 10.1-Inch ... 3813.0
308 SAMSUNG ,,Android 4.4 Kit Kat OS, 1.2 GHz quad-core Qu... 3,006 ratings NaN 4.3 out of 5 stars Samsung Galaxy Tab 4 SM-T530NYKAXAR 10.1-Inch ... 3006.0

Amazon Fire HD being the most highly reviewed tablets with some having nearly 100,000 reviews or more! Making their tablets the most reviewed products on the Amazon market Place¶

image.png

Analyzing the Overall rating Scores of Tablets to Amazons Fire HD.¶

4.0 out of 5 stars    104
5.0 out of 5 stars     99
3.5 out of 5 stars     83
3.7 out of 5 stars     79
3.9 out of 5 stars     78
4.1 out of 5 stars     71
3.8 out of 5 stars     67
4.2 out of 5 stars     66
3.6 out of 5 stars     64
4.5 out of 5 stars     63
3.0 out of 5 stars     55
4.6 out of 5 stars     55
4.4 out of 5 stars     55
4.3 out of 5 stars     50
3.3 out of 5 stars     47
3.4 out of 5 stars     44
4.7 out of 5 stars     42
3.2 out of 5 stars     41
3.1 out of 5 stars     35
1.0 out of 5 stars     33
4.8 out of 5 stars     27
2.0 out of 5 stars     21
2.6 out of 5 stars     19
2.9 out of 5 stars     18
2.8 out of 5 stars     15
2.5 out of 5 stars     13
2.7 out of 5 stars     12
4.9 out of 5 stars      6
2.3 out of 5 stars      6
1.9 out of 5 stars      5
2.4 out of 5 stars      3
2.2 out of 5 stars      3
1.6 out of 5 stars      3
2.1 out of 5 stars      2
1.7 out of 5 stars      2
1.3 out of 5 stars      1
1.4 out of 5 stars      1
1.8 out of 5 stars      1
Name: rating, dtype: int64
1     46
2    112
3    593
4    539
5     99
Name: first, dtype: int64
  • As you can see from the bar chart most tablets have a fairly good Rating between 3-4+ stars
  • Roughly 40% for both 3 star and 4 star. And ~ 9% for 5 star.
  • From this we can infer that overall most customers are satisfied with their tablet purchase from Amazon (89% have 3-star rating or higher)

image.png

Now how does Amazons Tablets Compare?¶

brand description num_reviews price rating title reviews_float first
46 Amazon 8" HD display; 16 or 32 GB of internal storage... 76,789 ratings NaN 4.4 out of 5 stars Fire HD 8 Tablet (8" HD Display, 32 GB) - Blac... 76789.0 4
100 Amazon Our largest display on our thinnest tablet yet... 16,758 ratings NaN 4.0 out of 5 stars Fire HD 10 Tablet with Alexa, 10.1" HD Display... 16758.0 4
345 Amazon Our most powerful tablet ever,All-new Amazon U... 6,587 ratings NaN 4.2 out of 5 stars Fire HDX 8.9 Tablet, 8.9" HDX Display, Wi-Fi, ... 6587.0 4
359 Amazon Our most powerful tablet ever,All-new Amazon U... 6,587 ratings NaN 4.2 out of 5 stars Fire HDX 8.9 Tablet, 8.9" HDX Display, Wi-Fi, ... 6587.0 4
387 Amazon Save up to $99 on a full-featured Fire HD 10 t... 3 ratings $234.98 4.6 out of 5 stars Fire HD 10 Kids Tablet 32GB Blue with Poptime ... 3.0 4
... ... ... ... ... ... ... ... ...
9540 Amazon 8" HD display, 2X the storage (32 or 64 GB of ... 6,978 ratings $109.99 4.5 out of 5 stars All-new Fire HD 8 Plus tablet, HD display, 32 ... 6978.0 4
9566 Amazon 8" HD display, 2X the storage (32 or 64 GB of ... 6,985 ratings $109.99 4.5 out of 5 stars All-new Fire HD 8 Plus tablet, HD display, 32 ... 6985.0 4
9573 Amazon 8" HD display, 2X the storage (32 or 64 GB of ... 30,108 ratings $89.99 4.5 out of 5 stars All-new Fire HD 8 tablet, 8" HD display, 32 GB... 30108.0 4
9574 Amazon 10.1" 1080p full HD display; 32 or 64 GB of in... 77,593 ratings $149.99 4.6 out of 5 stars Fire HD 10 Tablet (10.1" 1080p full HD display... 77593.0 4
9575 Amazon 7" IPS display; 16 or 32 GB of internal storag... 110,184 ratings $49.99 4.4 out of 5 stars Fire 7 tablet (7" display, 16 GB) - Black 110184.0 4

101 rows × 8 columns

4.6 out of 5 stars    6
5.0 out of 5 stars    5
4.2 out of 5 stars    5
4.0 out of 5 stars    4
4.5 out of 5 stars    4
4.4 out of 5 stars    2
2.0 out of 5 stars    2
3.3 out of 5 stars    1
4.7 out of 5 stars    1
4.3 out of 5 stars    1
3.5 out of 5 stars    1
Name: rating, dtype: int64
2     2
3     2
4    23
5     5
Name: first, dtype: int64
  • As you can see overall most customers are overwhelmingly satisfed with Amazons brand of tablets. With No 1 star reviews and the vast majority of reviews being over 4 stars (Nearly 80%). Add to the fact that the Fire HD tablets are some of the most highly reviewed products on the Amazon market place its clear that most consumers opt for the Fire HD over other tablet manufactuerers

image.png

Word Cloud Analysis¶

What words do Sellers use to market their Tablets?¶

Word Cloud of All Descriptions¶

  • Descriptions parsed into a List by each line or bullet point via scrapy
  • Due to the high variance of the technical details page, the description was the best place to parse technical infomation

image.png

As We can see the most common features listed are:¶
  • Tablet PC
  • WiFi
  • Bluetooth
  • Quad Core
  • Dual SIM
  • Android Tablet
  • Core 1.3GHz
  • 16GB / 32GB
  • touch screen
So we can say most tablets have at minium these features: WiFi, Bluetooth, A quad core processor, Running Android OS, Dual Sim capability, either 16GB or 32 GB internal memory, 1.3Ghz processing speed, and of course a touch screen.¶






Now what are the most common features implemented in the Fire HD Tablet?¶

image.png

As We can see the most common features listed are:¶

  • Fire Tablet
  • watching video
  • web watching
  • listening music
  • Quad Core
  • hands free
  • hours reading
We can infer from the word cloud that Amazon markets its tablets more towards people looking to do light tasks such as reading, web browsing, and watching videos on their tablet.¶






Conclusion:¶

  • Amazon dominates the market on basic tablets for simple every day tasks such as watching videos, reading articles, web browsing, and video conferencing.
  • They have the highest rated product having primarily 4-5 star reviews and the highest number of reviews of any other tablet on the Amazon marketplace.
  • They have a wide selection of different types of tablets by size, memory, performance, and even kids versions.
  • Their product is easily affordable compared to other brands such as the Microsoft Surface or Apple iPad, and their tablets regularly come on sale or include deals.
  • Some of them even come built in with the voice assistant Alexa.

Overall the Amazon Fire HD tablet is one of the most reliable tablets you can buy for the money, with solid performance, good battery life, and stellar reviews all across the board you cant go wrong with a Fire HD.¶

Going Forward¶

  • Add price comparisons of most popular brands
  • average out the prices of popular brands and compare them to the Fire HD Tablet
  • Be able to sort the number of reviews to see highest reviewed products
  • Comparison of specs between most popular devices
  • Create more interactive charts using plotly so data can be read by hovering over
  • Continue cleaning data, unforunately even when setting the filters on amazon.com to "electronics" and "Tablets", there are still several entries scraped which were not Tablets.
  • There are items listed such as: Clothing, accessories, books, etc. Though not present in high enough frequencies to have an impact on the analysis, these should still be cleaned out.
  • Include Review infomration